package com.example.stlink.model.constants;

import com.example.stlink.model.contract.UserInfoContract;

/**
 * 本地SQLite相关的SQL语句定义
 */
public final class SQLiteConstants {

/*==================================================================================================*/
    public static final String USER_INFO_SQL_CREATE_ENTRIES =
        "CREATE TABLE  IF NOT EXISTS " + UserInfoContract.UserEntry.TABLE_NAME + " ( " +
            UserInfoContract.UserEntry._ID + " INTEGER PRIMARY KEY, " +
                UserInfoContract.UserEntry.COLUMN_NAME_APP_KEY + " VARCHAR(256), " +
                UserInfoContract.UserEntry.COLUMN_NAME_AVATAR + " VARCHAR(256), " +
                UserInfoContract.UserEntry.COLUMN_NAME_COLLEGE_NAME + " VARCHAR(256), " +
                UserInfoContract.UserEntry.COLUMN_NAME_CREATE_TIME + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_EMAIL + " VARCHAR(256), " +
                UserInfoContract.UserEntry.COLUMN_NAME_GENDER + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_ID + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_ID_NUMBER + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_IN_SCHOOL_TIME + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_LAST_UPDATE_TIME + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_PHONE + " VARCHAR(256), " +
                UserInfoContract.UserEntry.COLUMN_NAME_REAL_NAME + " VARCHAR(256), " +
                UserInfoContract.UserEntry.COLUMN_NAME_ROLE_ID + " INTEGER, " +
                UserInfoContract.UserEntry.COLUMN_NAME_USER_NAME + " VARCHAR(256) " +
                ")";
    public static final String USER_INFO_SQL_DELETE_ENTRIES =
        "DROP TABLE IF EXISTS " + UserInfoContract.UserEntry.TABLE_NAME;
    public static final int DATABASE_FIRST_VERSION = 1;
    public static final String USER_INFO_DATABASE_NAME = "userInfo.db";
/*==================================================================================================*/

}
